🔍 Query Optimization - emschwartz · Scour

Efficient Cost-Based Rewrite in a Bottom-Up Optimizer 💰Cost-Based Optimization

Designing the Right PostgreSQL Index Using Query Plans and Statistics 🌲GIN Indexes

beh74.github.io·1d·DEV, Hacker News

How we saved 40GB of Postgres space wasted on indexes 🌲GIN Indexes

peerlist.io·5d·Hacker News

Three indices walk into a FROM clause: ES|QL subqueries in Elasticsearch 📇Index Selection

Predicate pushdown, a planner perspective 📇Index Selection

floedb.ai·4d·Hacker News

Faster timeseries aggregations 💨Cache-Friendly Algorithms

opendata.dev·5d·Hacker News, r/programming

CA-SQL: Complexity-Aware Inference Time Reasoning for Text-to-SQL via Exploration and Compute Budget Allocation 🔄LLM RAG Pipelines

Diagnose and resolve database performance issues faster with Database Investigator 📊Database Profiling

datadoghq.com·4d

Detecting PostgreSQL optimization issues with deterministic analysis ⚡SQL Optimization

beh74.github.io·2d·Hacker News

GRAPE: Let GRPO Supervise Query Rewriting by Ranking for Retrieval 🌲GIN Indexes

PolySQL: Scaling Text-to-SQL Evaluation Across SQL Dialects via Automated Backend Isomorphism 🔄SQL Transpilation

Sparse Attention as a Range Searching Problem: Towards an Inference-Efficient Index for KV Cache 🧠LLM Inference

Towards Autonomous Business Intelligence via Data-to-Insight Discovery Agent 🦙Ollama

In-memory Multidimensional Indexing Using the skd-tree 🗂️Vector Indexes

Faster Iterative $\phi$ Queries on the Positional BWT 🗂️Vector Indexes

Submodular Ground-Set Pruning: Monotone Tightness and a Non-Monotone Separation 📇Index Selection

Nora: Normalized Orthogonal Row Alignment for Scalable Matrix Optimizer 📊Vector Databases

FINER-SQL: Boosting Small Language Models for Text-to-SQL 🔄SQL Transpilation

Adaptive Inverted-Index Routing for Granular Mixtures-of-Experts 🧩MoE

Rose-SQL: Role-State Evolution Guided Structured Reasoning for Multi-Turn Text-to-SQL 🔄SQL Transpilation

Log in to enable infinite scrolling